SQL Server Security Management

Navicat provides Server User to add, duplicate, edit, delete users/roles, grant/revoke server permissions and permissions on the selected database objects. The object pane displays all the users/roles that exist in the server.

The SQL Server sa log in is a server-level principal. By default, it is created when an instance is installed. In SQL Server 2005 or above, the default database of sa is master. This is a change of behavior from earlier versions of SQL Server.

By default, the database includes a guest user when a database is created. Permissions granted to the guest user are inherited by users who do not have a user account in the database. The guest user cannot be dropped, but it can be disabled by revoking its CONNECT permission. The CONNECT permission can be revoked by executing REVOKE CONNECT FROM GUEST within any database other than master or tempdb.

Manage Login

Just simply click -> Server Login to open an object pane for Server Login. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete login.

Add Server Login

To add a new login

Duplicate Server Login

To create a new login with modification as one of the existing logins

Edit Server Login

To edit an existing login

Delete Server Login

To delete a login

Manage Server Role

To edit an existing server role

Manage Database User

Just simply click -> Database User to open an object pane for Database User. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete database users.

Add Database User

To add a new database user

Duplicate Database User

To create a new database user with modification as one of the existing database users

Edit Database User

To edit an existing database user

Delete Database User

To delete a database user


Manage Database Role

Just simply click -> Database Role to open an object pane for Database Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete database roles.

Add Database Role

To add a new database role

Duplicate Database Role(Available only in Full Version)

To create a new database role with modification as one of the existing database roles

Edit Database Role

To edit an existing database role

Delete Database Role

To delete a Database Role

Manage Application Role

Just simply click -> Application Role to open an object pane for Application Role. A control-click displays the popup menu or use the object pane toolbar, allowing you to add, edit and delete application roles.

Add Application Role

To add a new application role

Duplicate Application Role

To create a new application role with modification as one of the existing application roles

Edit Application Role

To edit an existing application role

Delete Application Role

To delete an application role

Privilege Manager

To edit privilege according to the database objects by using Privilege Manager